﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head> 
   <title>Advanced export - global admin</title> 
   <!-- Template design (c) copyright 2008-2009 by Tim Green and EC Software -->
   <meta name="generator" content="Help &amp; Manual" /> 
   <meta name="keywords" content="" />
   <meta name="description" content="Advanced export - global admin" />
   <meta name="copyright" content="© 2012 Kentico Software" /> 
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 
   <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
   <link type="text/css" href="default.css" rel="stylesheet" /> 
   <link type="text/css" href="custom.css" rel="stylesheet" />

   <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
   <script type="text/javascript" src="jquery.scrollTo-min.js"></script>
   <script type="text/javascript" src="nsh.js"></script>



         
   <!-- CSS set with project variables and local attributes --> 
   <style type="text/css" media="screen"> 
   body { background: #fff; } 
   #breadcrumbs {width: 100%; background-color: white; border-bottom: 1px solid #000; padding: 0px 0px 5px 15px;
   margin: 3px 0; font-size: 8pt; color: #000;}
   #breadcrumbs a { color: #000; text-decoration: none;}
   #breadcrumbs a:visited { color: #000; }
   #breadcrumbs a:hover { color: #098ae2; text-decoration: none; }
   .help-url { font-size: 10pt; font-family: Arial, Verdana, Helvetica, sans-serif; 
               color: #1f84e8; text-align: center; margin: 5px 20px 10px 0px; 
               padding-top: 14px; border-top: 1px solid #000;}
   .help-url a { color: #098ae2; text-decoration: none; }
   .help-url a:visited { color: #098ae2; }
   .help-url a:hover { color: #098ae2; text-decoration: underline; }
   .highlight {background: #ffff40;}
   .breadhead {padding: 5px 0px 0px 0px !important;}    
   #innerdiv   
   {   
   padding-left: 5px;
   }
   

   </style> 

<!-- Adjustment for IE -->
<!--[if lte IE 8]>
<style type="text/css">
.topichead { padding-right: 0; }
   
   
   	.breadhead {
	margin: 0;
	padding-right: 5px;
	}
   
   
</style>
<![endif]-->
   
<script type="text/javascript">
// Initialize the page 
addEvent(window, "load", nsrInit);
addEvent(window, "load", doResize);
addEvent(window, "resize", doResize);
addEvent(window, "load", toggleJump);

</script>


<script type="text/javascript">
function mailFB_custom() {
var headerText = unQuot("Feedback on: Kentico CMS 6.0 Context Help - Advanced export - global admin".replace('&nbsp;',''));
var fb1 = "mailto:" + escape('Kentico Support Team <support@kentico.com>') + "?subject=" + headerText;
var titlePath = unQuot("General &gt; Dialogs &gt; Advanced export - global admin /");
var fb2 = "&body=Ref:%20" + titlePath + "%20ID:%20Advanced_export_admin%0A%0D%0A%0D" + unQuot("Dear Support Staff,") + "%0A%0D%0A%0D";
var fb = fb1 + fb2;
document.location.href=fb;
}
</script>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-105987-4']);
  _gaq.push(['_setDomainName', '.kentico.com']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>        
<script type="text/javascript" src="helpman_topicinit.js"></script>
<!-- Redirect browser to frame page if page is not in the content frame. -->
<script type="text/javascript">
<!--
if (location.search.lastIndexOf("toc=0")<=0) {
  if (parent.frames.length==0) { parent.location.href="index.html?advanced_export_admin.htm"; }
  else { parent.quicksync('a4.2.2'); }
}
//-->
</script>
<script type="text/javascript" src="highlight.js"></script></head> 
<body onload="highlight();">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>
<!--ZOOMSTOP-->

<div id="printheader">
<span id="printtitle">Kentico CMS 6.0 Context Help</span><br />
<p class="p_Heading1"><span class="f_Heading1">Advanced export - global admin</span></p>
</div>
<div id="idheader" style="border-bottom:1px solid #000;margin:0px 0px;"> 
<table id="breadtable" border="0" cellspacing="0" cellpadding="0" width="100%"> 
  <tr >
  <td align="left" class="breadhead" >
       <p id="breadcrumbs"><a href="mode_selection.htm"
        onmouseover="document.images.main.src='home_h.gif'" 
        onmouseout="document.images.main.src='home.gif'">
        <img name="main" src="home.gif" border="0" alt="Home topic" title="Home topic" /></a> 
        
        General &gt; Dialogs:</p> 
  </td>
  </tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="headtable"> 

<!-- Script version of NavHeader -->
  <tr id="scriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead" style="padding-left: 15px;"> 
    <p class="p_Heading1"><span class="f_Heading1">Advanced export - global admin</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="advanced_export_standard.htm"
        onmouseover="document.images.prev.src='button_prev_h.gif'" 
        onmouseout="document.images.prev.src='button_prev.gif'">
        <img name="prev" src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="dialogs_filesystem.htm"
        onmouseover="document.images.next.src='button_next_h.gif'" 
        onmouseout="document.images.next.src='button_next.gif'"><img name="next" src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>

   
   
   
   
   

     
   <td id="print-button" align="center" width="20" class="idnav" valign="bottom">
     <a href="javascript: print();" 
     onmouseover="document.images.printbutton.src='print_h.gif'" 
     onmouseout="document.images.printbutton.src='print.gif'"><img name="printbutton" border="0" alt="Print this topic" title="Print this topic" src="print.gif" /></a>
   </td>  
     
     

  
   <td id="mail-feedback" align="center" width="20" class="idnav" valign="bottom">
   <a href="#"
        onclick='mailFB_custom();'
        onmouseover="document.images.feedback.src='mail_h.gif'" 
        onmouseout="document.images.feedback.src='mail.gif'"><img name="feedback" src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>
<!-- End script navheader version -->

<!-- NoScript version of navheader -->

  <tr id="noScriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead"> 
    <p class="p_Heading1"><span class="f_Heading1">Advanced export - global admin</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="advanced_export_standard.htm">
        <img src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="dialogs_filesystem.htm">
        <img src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
  
   

     
     
   <td align="center" width="20" class="idnav" valign="bottom">
   <img border="0" alt="JavaScript is required for the print function" title="JavaScript is required for the print function" src="print_d.gif" />
   </td>
     
     
   
   <td align="center" width="20" class="idnav" valign="bottom">
   <a href="mailto:support@kentico.com?subject=Documentation%20feedback&body=Ref%20ID:%20Advanced_export_admin%0D%0D"><img src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>

<!-- End noscript navheader version -->
  </table>
<div id="autoTocWrapper"></div>
</div> 

<div id="idcontent"><div id="innerdiv">
<!--ZOOMRESTART-->
<p>In this dialog, you can adjust detailed options regarding how listing data will be exported. The following options are available:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table width="820" cellspacing="0" cellpadding="5" border="0" style="border: none; border-spacing:0px; border-collapse: collapse;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Export to</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>Type of file to which the data will be exported. You can choose from the following:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">Excel</span> - exports data to an XLSX spreadsheet.</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">CSV</span> - exports data to a CSV file.</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">XML</span> - exports data to an XML file.</td></tr></table></div></td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Delimiter</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>Displayed only when export to CSV is selected. Determines the value separation character used by the CSV file. The character can either be a comma (,) or a semicolon (;). See the <a href="http://devnet.kentico.com/docs/6_0/devguide/CSV_delimiters.htm" target="_blank" class="weblink">CSV delimiters</a> topic for more details.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Export raw database data</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>The format of data displayed in listings is not always identical to actual data stored in respective database columns. E.g. the <span style="font-weight: bold;">Enabled</span> column in user listing shows <span style="font-style: italic;">Yes/No</span> values, while boolean <span style="font-style: italic;">True/False</span> values are actually stored in the <span style="font-weight: bold;">UserEnabled</span> column of the <span style="font-weight: bold;">CMS_User</span> table.</p>
<p>&nbsp;</p>
<p>With this option enabled, raw data will be exported exactly as stored in the database and column headers will be identical to the database column names. If disabled, column headers and the actual data will be exported as shown in the listing.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Current page only</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>If enabled, only records displayed on the current page of the listing will be exported. If disabled, all records on all pages of the listing will be exported. The number of exported records in both cases can be limited by means of the <span style="font-weight: bold;">Number of records</span> value below.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Number of records</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>Specifies the number of data records that will be exported. Empty value results in all records being exported. The specified number of exported records can be limited by enabling the <span style="font-weight: bold;">Current page only</span> option above.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Export column header</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>If enabled, column headers will be included in the exported file. This option is not available when exporting to XML as column header names are used as names of the respective XML elements.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Order by</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>Standard SQL ORDER BY expression. Exported items will be ordered according to this expression in the exported file. </p>
<p>&nbsp;</p>
<p>Please note that you can select only columns that have a corresponding physical column in the database.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Use grid filter</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>If enabled, only data matching the filter above the listing will be exported. If disabled, all data will be exported regardless of the filter settings.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Where condition</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>Standard SQL WHERE condition. Only items matching this condition will be included in the export file.</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="29%" style="width:29%; border: solid 1px #000000;"><p>Columns</p>
</td>
<td valign="top" width="71%" style="width:71%; border: solid 1px #000000;"><p>In this section, you can use the check-boxes to choose which columns will be included in the export file. Bulk column selection can be performed using the following link buttons:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">Select all</span> - selects all columns listed in this section.</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">Deselect all</span> - deselects all columns listed in this section.</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td><span style="font-weight: bold;">Default selection</span> - selects columns that were selected initially when the dialog was opened.</td></tr></table></div><p>&nbsp;</p>
<p>If the <span style="font-weight: bold;">Export raw database data</span> option is enabled, listed column names are identical to the actual database columns name. If the option is disabled, column names are shown as in the listing.</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p>When you have the options adjusted, you can click <span style="font-weight: bold;">Export</span> to get the data exported to the chosen type of file. By clicking the <span style="font-weight: bold;">Preview</span> button, you get a maximum number of 100 records exported (unless you set a smaller number by means of the <span style="font-weight: bold;">Current page only</span> or <span style="font-weight: bold;">Number of records</span> options). This is useful in case that you are exporting large amounts of records and want to get a quick preview of the exported file without waiting for all records to be exported.</p>
<p>&nbsp;</p>
<p>More information on export of listings data can be found in <a href="http://devnet.kentico.com/docs/6_0/devguide/general_export_overview.htm" target="_blank" class="weblink">Developer's Guide -&gt; Modules -&gt; General export</a>.</p>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 

<noscript>
<p class="help-url"><b>Help URL:&nbsp;</b><a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?advanced_export_admin.htm" target="_top" title="Right-click to copy the URL of this help topic">
<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?advanced_export_admin.htm</a>
</p>
</noscript>
<script type="text/javascript">
var autoURL = true;
if (autoURL) {
      document.write(getHref("index.html","Help URL:","Right-click to copy the URL of this help topic"));
      } else {
             document.write('<p class="help-url"><b>Help URL:&nbsp;</b>');
             document.write('<a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?advanced_export_admin.htm" target="_top" title="Right-click to copy the URL of this help topic"><%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?advanced_export_admin.htm</a>');
             document.write('</p>');
      }
</script>

</div></div> 
</body>
</html>





